Vehicle Trip and Fuel Request Report
Introduction
This report allows users to generate a detailed view of vehicle trips and related fuel requests within the Frappe system. The report provides information such as trip status, truck details, driver information, fuel quantity, and costs, along with other relevant data points.
The report fetches data from the Trips and Fuel Requests Table to provide a comprehensive overview of the trip and fuel disbursements.
1. Report Overview
The report shows the following key fields:
Vehicle Trip: The ID of the trip.
Trip Date: Date of the trip.
Driver Name: Name of the driver assigned to the trip.
Truck Number: The truck’s internal fleet number.
Transporter Type: Type of transporter used for the trip.
Trip Status: Current status of the trip (e.g., "In Progress", "Completed").
Truck Licence Plate: License plate number of the truck.
Route: The route taken for the trip.
Item Name: Name of the fuel or item associated with the trip.
UOM: Unit of Measurement (e.g., Litres).
Quantity: Quantity of fuel or items disbursed.
Cost Per Litre: Cost per litre of fuel.
Currency: Currency used for fuel disbursement.
Total Cost: Total cost of fuel for the trip.
Disbursement Type: Type of disbursement (e.g., Fuel).
Supplier: Supplier of the fuel or item.
Status: Approval status of the disbursement.
Approved By: Name of the person who approved the disbursement.
Approved Date: Date when the disbursement was approved.
Round Trip: Indicates if the trip is a round trip.
Trip Completed: Indicates if the trip has been completed.
2. Generating the Report
To generate the report, follow these steps:
Access the Report:
In the Frappe system, go to the Reports section.
Search for the Vehicle Trip and Fuel Request Report.
Set Filters (optional):
- You can filter the report based on specific criteria like trip status, route, truck number, or driver. This allows you to generate customized reports based on your needs.
Click Generate:
- After setting the filters, click Generate to view the report. If no filters are set, the report will fetch all available data.
3. Report Columns
Each row in the report represents a trip, along with its corresponding fuel request details. The columns in the report are:
Vehicle Trip:Link to the associated trip document.
Trip Date: Date when the trip occurred.
Driver Name: Name of the driver responsible for the trip.
Truck Number: Internal number assigned to the truck.
Transporter Type: Describes the type of transporter for the trip.
Trip Status: Current state of the trip (e.g., "En Route", "Completed").
Truck Licence Plate: License plate number of the truck.
Route: The route taken by the vehicle, linked to the trip routes.
Item Name: Name of the item or fuel type.
UOM: Unit of Measurement, such as liters.
Quantity: The quantity of fuel or items used for the trip.
Cost Per Litre: The cost of fuel per litre.
Currency: The currency used for fuel purchases.
Total Cost: Total fuel cost based on the quantity and cost per litre.
Disbursement Type: Type of fuel or item disbursed.
Supplier: Supplier of the fuel or disbursement item.
**Status:*** Status of the fuel request.
Approved By: Name of the person who approved the request.
Approved Date: Date when the request was approved.
Round Trip: Checkbox indicating if the trip was a round trip.
Trip Completed: Checkbox showing if the trip is completed.
How to Use the Report for Decision-Making
This report helps in:
Fuel Management: Tracking fuel disbursements and costs per trip.
Trip Tracking: Monitoring trip statuses and ensuring timely completion.
Supplier Management: Reviewing suppliers of fuel and managing related expenses.
Financial Oversight: Assessing the overall fuel cost and ensuring budgets are adhered to.